Overview

Dataset info

Number of variables31
Number of observations821723
Missing cells2296145 (9.0%)
Duplicate rows0 (0.0%)
Total size in memory188.9 MiB
Average record size in memory241.0 B

Variables types

Numeric3
Categorical24
Boolean1
Date0
URL0
Text (Unique)0
Rejected3
Unsupported0

Warnings

AGE_AT_INCIDENT has 13351 (1.6%) missing values Missing
ARRAIGNMENT_DATE has a high cardinality: 3206 distinct values Warning
ARRAIGNMENT_DATE has 141443 (17.2%) missing values Missing
ARREST_DATE has a high cardinality: 258283 distinct values Warning
ARREST_DATE has 17929 (2.2%) missing values Missing
CASE_PARTICIPANT_ID is highly correlated with CASE_ID (ρ = 0.9862112296) Rejected
CHARGE_DISPOSITION_REASON has 602411 (73.3%) missing values Missing
CHARGE_ID is highly correlated with CASE_PARTICIPANT_ID (ρ = 0.9583841653) Rejected
CHARGE_VERSION_ID is highly correlated with CHARGE_ID (ρ = 0.9683668011) Rejected
COURT_FACILITY has 8469 (1.0%) missing values Missing
DISPOSITION_CHARGED_ACT has a high cardinality: 52 distinct values Warning
DISPOSITION_CHARGED_ACT has 23341 (2.8%) missing values Missing
DISPOSITION_CHARGED_AOIC has a high cardinality: 3298 distinct values Warning
DISPOSITION_CHARGED_CHAPTER has a high cardinality: 858 distinct values Warning
DISPOSITION_CHARGED_OFFENSE_TITLE has a high cardinality: 2302 distinct values Warning
DISPOSITION_CHARGED_SECTION has a high cardinality: 1635 distinct values Warning
DISPOSITION_CHARGED_SECTION has 23341 (2.8%) missing values Missing
DISPOSITION_DATE only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
DISPOSITION_DATE has a high cardinality: 2802 distinct values Warning
INCIDENT_BEGIN_DATE has a high cardinality: 6465 distinct values Warning
INCIDENT_CITY has a high cardinality: 268 distinct values Warning
INCIDENT_CITY has 73668 (9.0%) missing values Missing
INCIDENT_END_DATE has a high cardinality: 4287 distinct values Warning
INCIDENT_END_DATE has 729228 (88.7%) missing values Missing
JUDGE has a high cardinality: 403 distinct values Warning
JUDGE has 69566 (8.5%) missing values Missing
LAW_ENFORCEMENT_AGENCY has a high cardinality: 525 distinct values Warning
OFFENSE_CATEGORY has a high cardinality: 88 distinct values Warning
RECEIVED_DATE only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
RECEIVED_DATE has a high cardinality: 6033 distinct values Warning
UNIT has a high cardinality: 101 distinct values Warning
UNIT has 571681 (69.6%) missing values Missing
UPDATED_OFFENSE_CATEGORY has a high cardinality: 81 distinct values Warning

Variables

AGE_AT_INCIDENT
Numeric

Distinct count88
Unique (%)< 0.1%
Missing (%)1.6%
Missing (n)13351
Infinite (%)0.0%
Infinite (n)0
Mean31.91356826
Minimum17
Maximum156
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum17
5-th percentile18
Q122
Median29
Q339
95-th percentile55
Maximum156
Range139
Interquartile range17

Descriptive statistics

Standard deviation11.72520023
Coef of variation0.3674048647
Kurtosis0.1671993046
Mean31.91356826
MAD9.628208641
Skewness0.8955357052
Sum25798035
Variance137.4803204
Memory size6.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
19 44294 5.4%
 
20 43202 5.3%
 
21 39147 4.8%
 
22 36973 4.5%
 
23 36110 4.4%
 
24 33820 4.1%
 
18 32061 3.9%
 
25 31087 3.8%
 
26 30363 3.7%
 
27 28925 3.5%
 
Other values (77) 452390 55.1%
 

Minimum 5 values

ValueCountFrequency (%) 
17 12943 1.6%
 
18 32061 3.9%
 
19 44294 5.4%
 
20 43202 5.3%
 
21 39147 4.8%
 

Maximum 5 values

ValueCountFrequency (%) 
156 1 < 0.1%
 
130 1 < 0.1%
 
127 2 < 0.1%
 
125 1 < 0.1%
 
124 1 < 0.1%
 

ARRAIGNMENT_DATE
Categorical

Distinct count3206
Unique (%)0.4%
Missing (%)17.2%
Missing (n)141443
2/14/2012 12:00:00 AM
 
944
12/6/2011 12:00:00 AM
 
935
3/20/2014 12:00:00 AM
 
896
Other values (3202)
677505
(Missing)
141443
ValueCountFrequency (%) 
2/14/2012 12:00:00 AM 944 0.1%
 
12/6/2011 12:00:00 AM 935 0.1%
 
3/20/2014 12:00:00 AM 896 0.1%
 
9/3/2013 12:00:00 AM 872 0.1%
 
12/13/2011 12:00:00 AM 760 0.1%
 
9/8/2011 12:00:00 AM 759 0.1%
 
11/17/2011 12:00:00 AM 752 0.1%
 
2/19/2013 12:00:00 AM 725 0.1%
 
2/21/2012 12:00:00 AM 722 0.1%
 
4/18/2013 12:00:00 AM 721 0.1%
 
Other values (3195) 672194 81.8%
 
(Missing) 141443 17.2%
 
Max length22
Mean length17.85882469
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

ARREST_DATE
Categorical

Distinct count258283
Unique (%)31.4%
Missing (%)2.2%
Missing (n)17929
3/10/2012 1:49:00 AM
 
326
4/14/2010 5:51:00 AM
 
301
3/1/2013 11:55:00 AM
 
294
Other values (258279)
802873
(Missing)
 
17929
ValueCountFrequency (%) 
3/10/2012 1:49:00 AM 326 < 0.1%
 
4/14/2010 5:51:00 AM 301 < 0.1%
 
3/1/2013 11:55:00 AM 294 < 0.1%
 
1/25/2012 10:40:00 AM 287 < 0.1%
 
8/1/2013 8:15:00 PM 262 < 0.1%
 
10/18/2011 9:06:00 AM 244 < 0.1%
 
12/28/2011 3:30:00 PM 218 < 0.1%
 
1/2/2011 1:42:00 AM 216 < 0.1%
 
11/2/2008 4:40:00 AM 198 < 0.1%
 
3/30/2017 10:58:00 AM 195 < 0.1%
 
Other values (258272) 801253 97.5%
 
(Missing) 17929 2.2%
 
Max length22
Mean length19.8829058
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

CASE_ID
Numeric

Distinct count291211
Unique (%)35.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.182481192e+11
Minimum4.467030971e+10
Maximum1.312048319e+11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4.467030971e+10
5-th percentile7.185488393e+10
Q11.163808261e+11
Median1.20743827e+11
Q31.252188738e+11
95-th percentile1.288860775e+11
Maximum1.312048319e+11
Range8.653452222e+10
Interquartile range8838047627

Descriptive statistics

Standard deviation1.340114151e+10
Coef of variation0.1133306948
Kurtosis9.655431823
Mean1.182481192e+11
MAD7351650408
Skewness-3.107491641
Sum9.716719924e+16
Variance1.795905938e+20
Memory size6.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[4.46703097e+10 4.47151193e+10 4.62981948e+10 4.63138759e+10 4.66250245e+10 ... 1.30968388e+11 1.30981288e+11 1.30985996e+11 1.31082690e+11 1.31204832e+11], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1.158186255e+11 430 0.1%
 
1.261964064e+11 400 < 0.1%
 
5.424918312e+10 392 < 0.1%
 
1.194551677e+11 327 < 0.1%
 
1.207425129e+11 320 < 0.1%
 
1.125396841e+11 301 < 0.1%
 
1.158679906e+11 300 < 0.1%
 
6.360703087e+10 297 < 0.1%
 
1.187367686e+11 294 < 0.1%
 
1.166253735e+11 294 < 0.1%
 
Other values (291201) 818368 99.6%
 

Minimum 5 values

ValueCountFrequency (%) 
4.467030971e+10 20 < 0.1%
 
4.475992891e+10 7 < 0.1%
 
4.492563245e+10 1 < 0.1%
 
4.497236934e+10 1 < 0.1%
 
4.532891885e+10 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.312048319e+11 1 < 0.1%
 
1.312045691e+11 1 < 0.1%
 
1.312044815e+11 1 < 0.1%
 
1.312020286e+11 1 < 0.1%
 
1.312018972e+11 1 < 0.1%
 

CASE_PARTICIPANT_ID
Highly correlated

This variable is highly correlated with CASE_ID and should be ignored for analysis

Correlation0.9862112296

CHARGE_COUNT
Numeric

Distinct count301
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5.607300757
Minimum1
Maximum301
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q35
95-th percentile19
Maximum301
Range300
Interquartile range4

Descriptive statistics

Standard deviation12.17660369
Coef of variation2.171562436
Kurtosis116.1180508
Mean5.607300757
MAD5.349972242
Skewness8.708297781
Sum4607648
Variance148.2696774
Memory size6.3 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 147.5 183.5 244.5 261.5 301. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 304534 37.1%
 
2 130317 15.9%
 
3 77082 9.4%
 
4 60487 7.4%
 
5 44012 5.4%
 
6 37213 4.5%
 
7 26410 3.2%
 
8 21673 2.6%
 
9 16220 2.0%
 
10 12947 1.6%
 
Other values (291) 90828 11.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 304534 37.1%
 
2 130317 15.9%
 
3 77082 9.4%
 
4 60487 7.4%
 
5 44012 5.4%
 

Maximum 5 values

ValueCountFrequency (%) 
301 1 < 0.1%
 
300 1 < 0.1%
 
299 1 < 0.1%
 
298 1 < 0.1%
 
297 1 < 0.1%
 

CHARGE_DISPOSITION
Categorical

Distinct count36
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Nolle Prosecution
502967
Plea Of Guilty
203390
FNG
 
37557
Other values (33)
 
77809
ValueCountFrequency (%) 
Nolle Prosecution 502967 61.2%
 
Plea Of Guilty 203390 24.8%
 
FNG 37557 4.6%
 
FNPC 34152 4.2%
 
Finding Guilty 22345 2.7%
 
Verdict Guilty 4721 0.6%
 
Verdict-Not Guilty 3943 0.5%
 
Death Suggested-Cause Abated 3647 0.4%
 
BFW 2052 0.2%
 
Superseded by Indictment 1664 0.2%
 
Other values (26) 5285 0.6%
 
Max length32
Mean length15.03468931
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

CHARGE_DISPOSITION_REASON
Categorical

Distinct count30
Unique (%)< 0.1%
Missing (%)73.3%
Missing (n)602411
PG to Other Count/s
127892
Proceeding on Other Count/s
 
33162
Nolle - AONIC
 
13811
Other values (26)
 
44447
(Missing)
602411
ValueCountFrequency (%) 
PG to Other Count/s 127892 15.6%
 
Proceeding on Other Count/s 33162 4.0%
 
Nolle - AONIC 13811 1.7%
 
DGS Graduation 4692 0.6%
 
Motion to Quash Arrest & Suppress Evidence/Sustained 4450 0.5%
 
Re-Indictment 4221 0.5%
 
Misdemeanor Amount 4138 0.5%
 
Proceeding on Other Case/s 3727 0.5%
 
Complaining Witness Not in Court 3668 0.4%
 
No Lab 3368 0.4%
 
Other values (19) 16183 2.0%
 
(Missing) 602411 73.3%
 
Max length52
Mean length7.668299415
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

CHARGE_ID
Highly correlated

This variable is highly correlated with CASE_PARTICIPANT_ID and should be ignored for analysis

Correlation0.9583841653

CHARGE_VERSION_ID
Highly correlated

This variable is highly correlated with CHARGE_ID and should be ignored for analysis

Correlation0.9683668011

COURT_FACILITY
Categorical

Distinct count17
Unique (%)< 0.1%
Missing (%)1.0%
Missing (n)8469
26TH Street
440181
Markham Courthouse
 
79200
Bridgeview Courthouse
 
77590
Other values (13)
216283
ValueCountFrequency (%) 
26TH Street 440181 53.6%
 
Markham Courthouse 79200 9.6%
 
Bridgeview Courthouse 77590 9.4%
 
Skokie Courthouse 75543 9.2%
 
Maywood Courthouse 47226 5.7%
 
Rolling Meadows Courthouse 37654 4.6%
 
Harrison & Kedzie (Area 4) 15174 1.8%
 
51st & Wentworth (Area 1) 10914 1.3%
 
Grand & Central (Area 5) 9650 1.2%
 
727 E. 111th Street (Area 2) 8611 1.0%
 
Other values (6) 11511 1.4%
 
(Missing) 8469 1.0%
 
Max length30
Mean length15.0265284
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

COURT_NAME
Categorical

Distinct count9
Unique (%)< 0.1%
Missing (%)0.7%
Missing (n)5550
District 1 - Chicago
495971
District 6 - Markham
 
79859
District 5 - Bridgeview
 
77708
Other values (5)
162635
ValueCountFrequency (%) 
District 1 - Chicago 495971 60.4%
 
District 6 - Markham 79859 9.7%
 
District 5 - Bridgeview 77708 9.5%
 
District 2 - Skokie 76650 9.3%
 
District 4 - Maywood 47754 5.8%
 
District 3 - Rolling Meadows 37828 4.6%
 
PROMIS 402 < 0.1%
 
Traffic 1 < 0.1%
 
(Missing) 5550 0.7%
 
Max length28
Mean length20.4370171
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

DISPOSITION_CHARGED_ACT
Categorical

Distinct count52
Unique (%)< 0.1%
Missing (%)2.8%
Missing (n)23341
5
600690
570
160533
550
 
24394
Other values (48)
 
12765
(Missing)
 
23341
ValueCountFrequency (%) 
5 600690 73.1%
 
570 160533 19.5%
 
550 24394 3.0%
 
150 3972 0.5%
 
335 1959 0.2%
 
65 1876 0.2%
 
646 1486 0.2%
 
250 1371 0.2%
 
154 474 0.1%
 
70 369 < 0.1%
 
Other values (41) 1258 0.2%
 
(Missing) 23341 2.8%
 
Max length5
Mean length1.53471547
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

DISPOSITION_CHARGED_AOIC
Categorical

Distinct count3298
Unique (%)0.4%
Missing (%)< 0.1%
Missing (n)193
5101110
 
103600
0012476
 
22523
0014717
 
21035
Other values (3294)
674372
ValueCountFrequency (%) 
5101110 103600 12.6%
 
0012476 22523 2.7%
 
0014717 21035 2.6%
 
0012309 18769 2.3%
 
0735000 18494 2.3%
 
0016108 17439 2.1%
 
0012474 17283 2.1%
 
5097200 16471 2.0%
 
0014716 15720 1.9%
 
0014056 15068 1.8%
 
Other values (3287) 555128 67.6%
 
Max length10
Mean length7.156510162
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

DISPOSITION_CHARGED_CHAPTER
Categorical

Distinct count858
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
720
672604
625
 
111167
730
 
9316
Other values (855)
 
28636
ValueCountFrequency (%) 
720 672604 81.9%
 
625 111167 13.5%
 
730 9316 1.1%
 
720-5\8-4(720-5\9-1) 2514 0.3%
 
15 1959 0.2%
 
430 1917 0.2%
 
720-570\402(C) 940 0.1%
 
720-5\10-3.1 885 0.1%
 
720-5\18-2(A)(2) 794 0.1%
 
720-5\12-4(A) 780 0.1%
 
Other values (848) 18847 2.3%
 
Max length24
Mean length3.357978297
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

DISPOSITION_CHARGED_CLASS
Categorical

Distinct count14
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)170
4
341449
2
174458
3
122749
Other values (10)
182897
ValueCountFrequency (%) 
4 341449 41.6%
 
2 174458 21.2%
 
3 122749 14.9%
 
X 78539 9.6%
 
1 64240 7.8%
 
M 22303 2.7%
 
A 16428 2.0%
 
B 739 0.1%
 
C 455 0.1%
 
Z 115 < 0.1%
 
Other values (3) 78 < 0.1%
 
(Missing) 170 < 0.1%
 
Max length3
Mean length1.000413765
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

DISPOSITION_CHARGED_OFFENSE_TITLE
Categorical

Distinct count2302
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
POSSESSION OF A CONTROLLED SUBSTANCE
 
105281
AGGRAVATED UNLAWFUL USE OF WEAPON
 
98855
AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL
 
54853
Other values (2299)
562734
ValueCountFrequency (%) 
POSSESSION OF A CONTROLLED SUBSTANCE 105281 12.8%
 
AGGRAVATED UNLAWFUL USE OF WEAPON 98855 12.0%
 
AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL 54853 6.7%
 
AGGRAVATED BATTERY 45636 5.6%
 
FELONY DRIVING WHILE DRIVER?S LICENSE, PERMIT, OR PRIVILEGE TO OPERATE A MOTOR VEHICLE IS SUSPENDED OR REVOKED 37911 4.6%
 
UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON 35566 4.3%
 
[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE] 25699 3.1%
 
RETAIL THEFT 21282 2.6%
 
THEFT 18581 2.3%
 
[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/ DELIVERY OF A CONTROLLED SUBSTANCE] 17002 2.1%
 
Other values (2292) 361057 43.9%
 
Max length120
Mean length38.8769634
Min length5
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

DISPOSITION_CHARGED_SECTION
Categorical

Distinct count1635
Unique (%)0.2%
Missing (%)2.8%
Missing (n)23341
402(c)
 
102823
24-1.6(a)(1)
 
72148
11-501(a)
 
55022
Other values (1631)
568389
ValueCountFrequency (%) 
402(c) 102823 12.5%
 
24-1.6(a)(1) 72148 8.8%
 
11-501(a) 55022 6.7%
 
6-303(a) 40748 5.0%
 
24-1.1(a) 35566 4.3%
 
24-1.6(a)(2) 35365 4.3%
 
16-25(a)(1) 17456 2.1%
 
12-3.05(d)(4) 17394 2.1%
 
401(d)(i) 16402 2.0%
 
8-4(a)(720-5/9-1(a)(1)) 12253 1.5%
 
Other values (1624) 393205 47.9%
 
(Missing) 23341 2.8%
 
Max length30
Mean length9.444253112
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

DISPOSITION_DATE
Categorical

Distinct count2802
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
10/30/2013 12:00:00 AM
 
801
5/11/2012 12:00:00 AM
 
760
7/10/2014 12:00:00 AM
 
733
Other values (2799)
819429
ValueCountFrequency (%) 
10/30/2013 12:00:00 AM 801 0.1%
 
5/11/2012 12:00:00 AM 760 0.1%
 
7/10/2014 12:00:00 AM 733 0.1%
 
9/17/2013 12:00:00 AM 726 0.1%
 
12/5/2013 12:00:00 AM 705 0.1%
 
10/6/2016 12:00:00 AM 692 0.1%
 
4/13/2016 12:00:00 AM 687 0.1%
 
4/18/2013 12:00:00 AM 685 0.1%
 
8/29/2012 12:00:00 AM 680 0.1%
 
10/24/2013 12:00:00 AM 679 0.1%
 
Other values (2792) 814575 99.1%
 
Max length22
Mean length20.95091412
Min length20
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

GENDER
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)2945
Male
731532
Female
 
87228
Male name, no gender given
 
9
Other values (2)
 
9
(Missing)
 
2945
ValueCountFrequency (%) 
Male 731532 89.0%
 
Female 87228 10.6%
 
Male name, no gender given 9 < 0.1%
 
Unknown 7 < 0.1%
 
Unknown Gender 2 < 0.1%
 
(Missing) 2945 0.4%
 
Max length26
Mean length4.209012039
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

INCIDENT_BEGIN_DATE
Categorical

Distinct count6465
Unique (%)0.8%
Missing (%)0.9%
Missing (n)7614
1/1/2012 12:00:00 AM
 
782
1/1/2013 12:00:00 AM
 
705
10/18/2011 12:00:00 AM
 
655
Other values (6461)
811967
(Missing)
 
7614
ValueCountFrequency (%) 
1/1/2012 12:00:00 AM 782 0.1%
 
1/1/2013 12:00:00 AM 705 0.1%
 
10/18/2011 12:00:00 AM 655 0.1%
 
1/19/2017 12:00:00 AM 610 0.1%
 
9/10/2011 12:00:00 AM 597 0.1%
 
1/1/2011 12:00:00 AM 593 0.1%
 
1/1/2010 12:00:00 AM 581 0.1%
 
8/4/2011 12:00:00 AM 558 0.1%
 
9/1/2010 12:00:00 AM 556 0.1%
 
12/27/2011 12:00:00 AM 552 0.1%
 
Other values (6454) 807920 98.3%
 
(Missing) 7614 0.9%
 
Max length22
Mean length20.76304545
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

INCIDENT_CITY
Categorical

Distinct count268
Unique (%)< 0.1%
Missing (%)9.0%
Missing (n)73668
Chicago
535463
Cicero
 
10716
Harvey
 
7704
Other values (264)
194172
(Missing)
 
73668
ValueCountFrequency (%) 
Chicago 535463 65.2%
 
Cicero 10716 1.3%
 
Harvey 7704 0.9%
 
Chicago Heights 6314 0.8%
 
Calumet City 5638 0.7%
 
Berwyn 5173 0.6%
 
Orland Park 5005 0.6%
 
Oak Lawn 4751 0.6%
 
Evanston 4511 0.5%
 
Dolton 4342 0.5%
 
Other values (257) 158438 19.3%
 
(Missing) 73668 9.0%
 
Max length21
Mean length7.347203376
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

INCIDENT_END_DATE
Categorical

Distinct count4287
Unique (%)0.5%
Missing (%)88.7%
Missing (n)729228
2/28/2013 12:00:00 AM
 
441
1/19/2017 12:00:00 AM
 
408
7/7/2004 12:00:00 AM
 
392
Other values (4283)
 
91254
(Missing)
729228
ValueCountFrequency (%) 
2/28/2013 12:00:00 AM 441 0.1%
 
1/19/2017 12:00:00 AM 408 < 0.1%
 
7/7/2004 12:00:00 AM 392 < 0.1%
 
8/22/2011 12:00:00 AM 389 < 0.1%
 
9/11/2011 12:00:00 AM 321 < 0.1%
 
1/31/2007 12:00:00 AM 294 < 0.1%
 
3/12/2014 12:00:00 AM 250 < 0.1%
 
10/31/2014 12:00:00 AM 217 < 0.1%
 
7/23/2014 12:00:00 AM 201 < 0.1%
 
11/2/2008 12:00:00 AM 198 < 0.1%
 
Other values (4276) 89384 10.9%
 
(Missing) 729228 88.7%
 
Max length22
Mean length5.021989162
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

JUDGE
Categorical

Distinct count403
Unique (%)< 0.1%
Missing (%)8.5%
Missing (n)69566
Brian K Flaherty
 
22254
James B Linn
 
19711
Michele M Pitman
 
19173
Other values (399)
691019
(Missing)
 
69566
ValueCountFrequency (%) 
Brian K Flaherty 22254 2.7%
 
James B Linn 19711 2.4%
 
Michele M Pitman 19173 2.3%
 
Nicholas R Ford 18793 2.3%
 
Colleen Ann Hyland 16314 2.0%
 
James Michael Obbish 15250 1.9%
 
Joseph Michael Claps 14873 1.8%
 
Charles P Burns 14554 1.8%
 
Vincent M Gaughan 14412 1.8%
 
Kenneth J Wadas 14371 1.7%
 
Other values (392) 582452 70.9%
 
(Missing) 69566 8.5%
 
Max length25
Mean length15.43718382
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

LAW_ENFORCEMENT_AGENCY
Categorical

Distinct count525
Unique (%)0.1%
Missing (%)0.1%
Missing (n)1062
CHICAGO PD
527681
COOK COUNTY SHERIFF (IL0160000)
 
19804
CICERO PD
 
10908
Other values (521)
262268
ValueCountFrequency (%) 
CHICAGO PD 527681 64.2%
 
COOK COUNTY SHERIFF (IL0160000) 19804 2.4%
 
CICERO PD 10908 1.3%
 
HARVEY PD 6713 0.8%
 
CHICAGO HEIGHTS PD 6267 0.8%
 
ORLAND PARK PD 5626 0.7%
 
CALUMET CITY PD 5353 0.7%
 
ISP DISTRICT CHICAGO 5333 0.6%
 
BERWYN PD 5100 0.6%
 
EVANSTON PD 4810 0.6%
 
Other values (514) 223066 27.1%
 
Max length60
Mean length12.31936188
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

OFFENSE_CATEGORY
Categorical

Distinct count88
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Narcotics
178419
UUW - Unlawful Use of Weapon
143369
Aggravated DUI
 
51759
Other values (85)
448176
ValueCountFrequency (%) 
Narcotics 178419 21.7%
 
UUW - Unlawful Use of Weapon 143369 17.4%
 
Aggravated DUI 51759 6.3%
 
PROMIS Conversion 47380 5.8%
 
Sex Crimes 35874 4.4%
 
Driving With Suspended Or Revoked License 30798 3.7%
 
Armed Robbery 25212 3.1%
 
Aggravated Battery Police Officer 23070 2.8%
 
Retail Theft 23025 2.8%
 
Homicide 22090 2.7%
 
Other values (78) 240727 29.3%
 
Max length45
Mean length17.29490351
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

PRIMARY_CHARGE
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
517189
True
304534
ValueCountFrequency (%) 
False 517189 62.9%
 
True 304534 37.1%
 

RACE
Categorical

Distinct count12
Unique (%)< 0.1%
Missing (%)0.5%
Missing (n)4183
Black
547288
White [Hispanic or Latino]
132201
White
 
107873
Other values (8)
 
30178
ValueCountFrequency (%) 
Black 547288 66.6%
 
White [Hispanic or Latino] 132201 16.1%
 
White 107873 13.1%
 
HISPANIC 18937 2.3%
 
Asian 5168 0.6%
 
White/Black [Hispanic or Latino] 4110 0.5%
 
Unknown 1141 0.1%
 
American Indian 427 0.1%
 
ASIAN 279 < 0.1%
 
Biracial 115 < 0.1%
 
(Missing) 4183 0.5%
 
Max length32
Mean length8.580931774
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

RECEIVED_DATE
Categorical

Distinct count6033
Unique (%)0.7%
Missing (%)0.0%
Missing (n)0
10/18/2011 12:00:00 AM
 
877
8/23/2011 12:00:00 AM
 
723
8/5/2011 12:00:00 AM
 
705
Other values (6030)
819418
ValueCountFrequency (%) 
10/18/2011 12:00:00 AM 877 0.1%
 
8/23/2011 12:00:00 AM 723 0.1%
 
8/5/2011 12:00:00 AM 705 0.1%
 
1/25/2012 12:00:00 AM 687 0.1%
 
11/16/2011 12:00:00 AM 641 0.1%
 
6/28/2013 12:00:00 AM 638 0.1%
 
1/21/2017 12:00:00 AM 630 0.1%
 
8/28/2012 12:00:00 AM 613 0.1%
 
10/21/2013 12:00:00 AM 587 0.1%
 
7/30/2012 12:00:00 AM 570 0.1%
 
Other values (6023) 815052 99.2%
 
Max length22
Mean length20.94496199
Min length20
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

UNIT
Categorical

Distinct count101
Unique (%)< 0.1%
Missing (%)69.6%
Missing (n)571681
District 11 - Harrison
 
48071
District 10 - Ogden
 
20216
District 15 - Austin
 
18183
Other values (97)
163572
(Missing)
571681
ValueCountFrequency (%) 
District 11 - Harrison 48071 5.9%
 
District 10 - Ogden 20216 2.5%
 
District 15 - Austin 18183 2.2%
 
District 7 - Englewood 17160 2.1%
 
District 6 - Gresham 14477 1.8%
 
District 25 - Grand Central 13682 1.7%
 
District 8 - Chicago Lawn 11383 1.4%
 
District 9 - Deering 11377 1.4%
 
District 5 - Calumet 11182 1.4%
 
District 4 - South Chicago 9813 1.2%
 
Other values (90) 74498 9.1%
 
(Missing) 571681 69.6%
 
Max length57
Mean length9.043476938
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

UPDATED_OFFENSE_CATEGORY
Categorical

Distinct count81
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Narcotics
188762
UUW - Unlawful Use of Weapon
148956
Aggravated DUI
 
65161
Other values (78)
418844
ValueCountFrequency (%) 
Narcotics 188762 23.0%
 
UUW - Unlawful Use of Weapon 148956 18.1%
 
Aggravated DUI 65161 7.9%
 
Sex Crimes 39498 4.8%
 
Homicide 31552 3.8%
 
Driving With Suspended Or Revoked License 31409 3.8%
 
Aggravated Battery With A Firearm 29055 3.5%
 
Armed Robbery 26005 3.2%
 
Aggravated Battery Police Officer 24684 3.0%
 
Retail Theft 22396 2.7%
 
Other values (71) 214245 26.1%
 
Max length45
Mean length17.5830651
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

AGE_AT_INCIDENTARRAIGNMENT_DATEARREST_DATECASE_IDCASE_PARTICIPANT_IDCHARGE_COUNTCHARGE_DISPOSITIONCHARGE_DISPOSITION_REASONCHARGE_IDCHARGE_VERSION_IDCOURT_FACILITYCOURT_NAMEDISPOSITION_CHARGED_ACTDISPOSITION_CHARGED_AOICDISPOSITION_CHARGED_CHAPTERDISPOSITION_CHARGED_CLASSDISPOSITION_CHARGED_OFFENSE_TITLEDISPOSITION_CHARGED_SECTIONDISPOSITION_DATEGENDERINCIDENT_BEGIN_DATEINCIDENT_CITYINCIDENT_END_DATEJUDGELAW_ENFORCEMENT_AGENCYOFFENSE_CATEGORYPRIMARY_CHARGERACERECEIVED_DATEUNITUPDATED_OFFENSE_CATEGORY
043.02/1/2012 12:00:00 AM12/29/2011 12:10:00 PM1162401774289083144308331Nolle ProsecutionProceeding on Other Count/s207789447264747211871053726TH StreetDistrict 1 - Chicago500123007202AGGRAVATED DOMESTIC BATTERY12-3.3(a)9/25/2012 12:00:00 AMMale12/8/2011 12:00:00 AMChicagoNaNVincent M GaughanCHICAGO PDDomestic BatteryTrueBlack1/3/2012 12:00:00 AMNaNDomestic Battery
142.01/31/2012 12:00:00 AM1/3/2012 12:05:00 PM1162402212309083147826071Plea Of GuiltyNaN207496969110047144541176426TH StreetDistrict 1 - Chicago500156007204RETAIL THEFT16A-3(a)6/22/2012 12:00:00 AMMale1/3/2012 12:00:00 AMChicagoNaNMichael BrownCHICAGO PDRetail TheftTrueBlack1/3/2012 12:00:00 AMNaNRetail Theft
250.02/9/2012 12:00:00 AM12/29/2011 11:55:00 AM1162402650329083153688961Plea Of GuiltyNaN207497087414447144568027826TH StreetDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)7/18/2012 12:00:00 AMMale12/29/2011 12:00:00 AMChicagoNaNWilliam H HooksCHICAGO PDNarcoticsTrueBlack1/3/2012 12:00:00 AMDistrict 12 - MonroeNarcotics
328.02/8/2012 12:00:00 AM12/29/2011 2:11:00 PM1162403526369083157206701Plea Of GuiltyNaN207497383175547144635156326TH StreetDistrict 1 - Chicago55050203007203[POSSESSION OF CANNABIS WITH INTENT TO DELIVER/DELIVERY OF CANNABIS]5(d)9/27/2012 12:00:00 AMMale12/29/2011 12:00:00 AMChicagoNaNWilliam H HooksCHICAGO PDNarcoticsTrueBlack1/3/2012 12:00:00 AMDistrict 4 - South ChicagoNarcotics
425.02/8/2012 12:00:00 AM12/29/2011 11:00:00 AM1162403964399083166587341Plea Of GuiltyNaN207497945121648787376756326TH StreetDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)1/3/2013 12:00:00 AMMale12/29/2011 12:00:00 AMChicagoNaNRaymond MylesCHICAGO PDNarcoticsTrueBlack1/3/2012 12:00:00 AMDistrict 11 - HarrisonNarcotics
518.02/8/2012 12:00:00 AM12/29/2011 11:00:00 AM1162403964399083170105081Plea Of GuiltyNaN207497945121647144762700526TH StreetDistrict 1 - Chicago57000130097201[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE]401(c)(1)2/22/2012 12:00:00 AMFemale12/29/2011 12:00:00 AMChicagoNaNRaymond MylesCHICAGO PDNarcoticsTrueBlack1/3/2012 12:00:00 AMDistrict 11 - HarrisonNarcotics
623.02/14/2012 12:00:00 AM12/27/2011 10:00:00 AM1162404402419083174795402Nolle ProsecutionNaN207673361031847184952528526TH StreetDistrict 1 - Chicago500123007202AGGRAVATED DOMESTIC BATTERY12-3.3(a)6/20/2013 12:00:00 AMMale12/16/2011 12:00:00 AMChicagoNaNJames Michael ObbishCHICAGO PDAggravated BatteryFalseBlack1/3/2012 12:00:00 AMNaNDomestic Battery
723.02/14/2012 12:00:00 AM12/27/2011 10:00:00 AM1162404402419083174795403Nolle ProsecutionNaN207725710747047197096072726TH StreetDistrict 1 - Chicago500148347202AGGRAVATED DOMESTIC BATTERY12-3.3(a-5)6/20/2013 12:00:00 AMMale12/16/2011 12:00:00 AMChicagoNaNJames Michael ObbishCHICAGO PDAggravated BatteryFalseBlack1/3/2012 12:00:00 AMNaNDomestic Battery
823.02/14/2012 12:00:00 AM12/27/2011 10:00:00 AM1162404402419083174795404Nolle ProsecutionNaN207962970303847251785654926TH StreetDistrict 1 - Chicago500148347202AGGRAVATED DOMESTIC BATTERY12-3.3(a-5)6/20/2013 12:00:00 AMMale12/16/2011 12:00:00 AMChicagoNaNJames Michael ObbishCHICAGO PDAggravated BatteryFalseBlack1/3/2012 12:00:00 AMNaNDomestic Battery
923.02/14/2012 12:00:00 AM12/27/2011 10:00:00 AM1162404402419083174795405Nolle ProsecutionNaN207673390607947184959241326TH StreetDistrict 1 - Chicago500160947203AGGRAVATED BATTERY12-3.05(a)(1)6/20/2013 12:00:00 AMMale12/16/2011 12:00:00 AMChicagoNaNJames Michael ObbishCHICAGO PDAggravated BatteryFalseBlack1/3/2012 12:00:00 AMNaNDomestic Battery

Last rows

AGE_AT_INCIDENTARRAIGNMENT_DATEARREST_DATECASE_IDCASE_PARTICIPANT_IDCHARGE_COUNTCHARGE_DISPOSITIONCHARGE_DISPOSITION_REASONCHARGE_IDCHARGE_VERSION_IDCOURT_FACILITYCOURT_NAMEDISPOSITION_CHARGED_ACTDISPOSITION_CHARGED_AOICDISPOSITION_CHARGED_CHAPTERDISPOSITION_CHARGED_CLASSDISPOSITION_CHARGED_OFFENSE_TITLEDISPOSITION_CHARGED_SECTIONDISPOSITION_DATEGENDERINCIDENT_BEGIN_DATEINCIDENT_CITYINCIDENT_END_DATEJUDGELAW_ENFORCEMENT_AGENCYOFFENSE_CATEGORYPRIMARY_CHARGERACERECEIVED_DATEUNITUPDATED_OFFENSE_CATEGORY
82171324.0NaN10/17/2019 5:25:00 PM13119887483311010454838631Nolle ProsecutionNaN2584493314237589445217220NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)10/18/2019 12:00:00 AMFemale10/17/2019 12:00:00 AMChicago10/17/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueWhite11/21/2019 12:00:00 AMNaNNarcotics
82171428.0NaN10/6/2019 1:03:00 PM13119905004211010468909581Nolle ProsecutionNaN2584493905759589445418605NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)10/7/2019 12:00:00 AMMale10/6/2019 12:00:00 AMChicago10/6/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/21/2019 12:00:00 AMNaNNarcotics
82171526.0NaN10/6/2019 1:03:00 PM13119944426111010521675671Nolle ProsecutionNaN2584499525220589446895432NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)10/7/2019 12:00:00 AMFemale10/6/2019 12:00:00 AMChicago10/6/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/21/2019 12:00:00 AMNaNNarcotics
82171665.0NaN11/6/2019 11:01:00 AM13119957566811010531056311Nolle ProsecutionNaN2584500116742589447163946NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)11/7/2019 12:00:00 AMMale11/6/2019 12:00:00 AMChicago11/6/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/21/2019 12:00:00 AMNaNNarcotics
82171756.0NaN11/5/2019 11:17:00 AM13119983848111010563888541Nolle ProsecutionMisdemeanor Amount2584509581097589449312058NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)11/6/2019 12:00:00 AMFemale11/5/2019 12:00:00 AMChicago11/5/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/21/2019 12:00:00 AMNaNNarcotics
82171862.0NaN11/6/2019 2:36:00 PM13120189718211010830064111Nolle ProsecutionNaN258459091540158946804090726TH StreetDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)11/7/2019 12:00:00 AMMale11/6/2019 12:00:00 AMChicago11/6/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/21/2019 12:00:00 AMNaNNarcotics
82171931.0NaN11/6/2019 2:13:00 PM13120202858811010846480231Nolle ProsecutionNaN2584594760295589469114963NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)11/7/2019 12:00:00 AMMale11/6/2019 12:00:00 AMChicago11/6/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/21/2019 12:00:00 AMNaNNarcotics
82172018.0NaN11/6/2019 2:08:00 PM13120448150911011214670241Nolle ProsecutionNaN2584653616754589482876304NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)11/7/2019 12:00:00 AMMale11/6/2019 12:00:00 AMChicago11/6/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/22/2019 12:00:00 AMNaNNarcotics
82172127.0NaN11/6/2019 6:27:00 PM13120456911311011231086351Nolle ProsecutionNaN2584658940454589484151745NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)11/7/2019 12:00:00 AMMale11/6/2019 12:00:00 AMChicago11/6/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/22/2019 12:00:00 AMNaNNarcotics
82172239.0NaN10/17/2019 12:47:00 PM13120483192611011258055681Nolle ProsecutionNaN2584662193826589484890159NaNDistrict 1 - Chicago57051011107204POSSESSION OF A CONTROLLED SUBSTANCE402(c)11/18/2019 12:00:00 AMFemale10/17/2019 12:00:00 AMChicago10/17/2019 12:00:00 AMNaNCHICAGO PDNarcoticsTrueBlack11/22/2019 12:00:00 AMNaNNarcotics